MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

10 rows where Artist Role = 91

View and edit SQL

Suggested facets: Is Public Domain, Object Name, Title, Artist Prefix, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Nationality, Artist Begin Date, Artist End Date, Object Begin Date, Object End Date, Credit Line, County, Classification

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Repository
17370 91.2.30 0 0 21867 Arms and Armor 5 Blade and mounting for a dagger (Tantō) 1289 Blade and Mounting for a Dagger (Tantō) Japanese 35         Swordsmith|Fittings maker 91 Blade attributed to|Mounting inscribed by Momokawa Nagayoshi|Kanō Natsuo Japanese, active early 15th century|Japanese, 1828–1898   Nagayoshi, Momokawa|Natsuo, Kanō 2671 Japanese|Japanese 72 1400 |1828 1450 |1898 blade, mid–late 14th century; mounting, 19th century 1325 1900 Steel, wood, lacquer, gold, silver, copper-silver alloy (shibuichi), copper-gold alloy (shakudō), copper 3448 L. 13 7/16 in. (34.2 cm); L. of blade 11 5/16 in. (28.8 cm); L. of cutting edge 8 5/16 in. (21.1 cm) Gift of Brayton Ives and W. T. Walters, 1891                       Swords 29   Metropolitan Museum of Art, New York, NY 1
18533 29.100.1370a–c 0 1 23055 Arms and Armor 5 Blade and mounting for a short sword (Wakizashi) 1294 Blade and Mounting for a Short Sword (Wakizashi) Japanese 35         Swordsmith|Fittings maker 91 Blade attributed to|Fittings by Yasutsugu|Nakamura Kazuyuki Japanese, active late 16th–early 17th century|Japanese, active early 19th century   Yasutsugu|Kazuyuki, Nakamura 2787 Japanese|Japanese 72 1550 |1800 1660 |1850 blade, early 17th century; mounting, 19th century 1601 1900 Steel, wood, lacquer, leather, copper-gold alloy (shakudō), copper-silver alloy (shibuichi), copper, gold, horn, silver 3884 L. 19 in. (48.2 cm); L. of blade 16 11/16 in. (42.4 cm); L. of cutting edge 14 5/8 in. (37.1 cm); D. of curvature 1/16 in. (0.2 cm) H. O. Havemeyer Collection, Bequest of Mrs. H. O. Havemeyer, 1929                       Swords 29   Metropolitan Museum of Art, New York, NY 1
20091 36.120.420a–d 0 0 24616 Arms and Armor 5 Blade and mounting for a short sword (Wakizashi) 1294 Blade and Mounting for a Short Sword (Wakizashi) Japanese 35         Swordsmith|Fittings maker 91 Blade inscribed by|Fittings inscribed by Yokoyama Kōzukedaijō Sukesada|Miboku Japanese, 1627–1716|Japanese, 1695–1769   Sukesada, Yokoyama Kōzukedaijō|Miboku 2843 Japanese|Japanese 72 1627 |1695 1716 |1769 blade, late 17th century; mounting, 19th century 1650 1900 Steel, wood, lacquer, ray skin (samé), thread, copper-gold alloy (shakudō), copper, gold, copper-silver alloy (shibuichi), iron 4259 L. 27 1/16 in. (68.7 cm); L. of blade 23 5/8 in. (60 cm); L. of cutting edge 17 3/4 in.(45.1 cm); D. of curvature 3/8 in. (0.9 cm); L. of knife (kozuka) 8 1/2 in. (21.6 cm); L. of hair dressing tool (kogai) 8 1/4 in. (21.0 cm) The Howard Mansfield Collection, Gift of Howard Mansfield, 1936                       Swords 29   Metropolitan Museum of Art, New York, NY 1
20092 36.120.419a–d 0 0 24617 Arms and Armor 5 Blade and mounting for a sword (Katana) 1284 Blade and Mounting for a Sword (Katana) Japanese 35         Swordsmith|Fittings maker 91 Blade inscribed by|Fittings inscribed by Yokoyama Kōzukedaijō Sukesada|Miboku Japanese, 1627–1716|Japanese, 1695–1769   Sukesada, Yokoyama Kōzukedaijō|Miboku 2843 Japanese|Japanese 72 1627 |1695 1716 |1769 blade, 17th century; mounting, 19th century 1601 1900 Steel, wood, lacquer, ray skin (samé), thread, copper-gold alloy (shakudō), gold, copper-silver alloy (shibuichi) 4260 L. 37 7/8 in. (96.2 cm); L. of blade 35 9/16 in. (90.3 cm); L. of cutting edge 27 3/8 in. (69.6 cm); D. of curvatuer 3/4 in. (1.9 cm); L. of scabbard 29 in. (73.7 cm); L. of knife (kozuka) 8 1/2 in. (21.6 cm); L. of hair dressing tool (kogai) 8 1/4 in. (21.0 cm) The Howard Mansfield Collection, Gift of Howard Mansfield, 1936                       Swords 29   Metropolitan Museum of Art, New York, NY 1
20105 36.120.417a, b 0 1 24630 Arms and Armor 5 Blade and mounting for a sword (Katana) 1284 Blade and Mounting for a Sword (Katana) Japanese 35         Swordsmith|Fittings maker 91 Blade inscribed by|Mounting by Sukemitsu of Bizen|Iwamoto Konkan Japanese, Bizen, Muromachi period, active ca. 1440|Japanese, Edo period, 1744–1801   Sukemitsu of Bizen|Iwamoto Konkan 2849 Japanese|Japanese 72 1400 |1744 1500 |1801 blade, dated 1440; mounting, late 18th century 1440 1900 Steel, wood, lacquer, ray skin (samé), thread, copper-gold alloy (shakudō), copper-silver alloy (shibuichi) 4267 L. 36 1/2 in. (92.7 cm); L. of blade 30 11/16 in. (77.9 cm); L of cutting edge 24 13/16 in. (63.1 cm); D. of curvature 11/16 in. (1.8 cm) The Howard Mansfield Collection, Gift of Howard Mansfield, 1936       Okayama Prefecture 98               Swords 29   Metropolitan Museum of Art, New York, NY 1
20106 36.120.418a–c 0 1 24631 Arms and Armor 5 Blade and mounting for a short sword (Wakizashi) 1294 Blade and Mounting for a Short Sword (Wakizashi) Japanese 35         Swordsmith|Fittings maker 91 Blade attributed to|Mounting by Yasumitsu|Iwamoto Konkan Japanese, Muromachi period, 15th century|Japanese, Edo period, 1744–1801   Yasumitsu|Iwamoto Konkan 2850 Japanese|Japanese 72 1400 |1744 1500 |1801 blade, 15th century; mounting, late 18th century 1401 1900 Steel, wood, lacquer, ray skin (samé); thread, copper-gold alloy (shakudō), copper-silver alloy (shibuichi) 4268 L. 27 1/16 in. (68.8 cm); L. of blade 24 5/16 in. (61.8 cm); L. of cutting edge 19 7/8 in. (50.5 cm); D. of curvature 9/16 in. (1.45 cm); L. of scabbard 19 3/4 in. (50.2 cm); knife (c); L. of blade 7 11/16 in. (19.5 cm); Wt. 0.4 oz. (11.3 g) The Howard Mansfield Collection, Gift of Howard Mansfield, 1936                       Swords 29   Metropolitan Museum of Art, New York, NY 1
20335 1972.12 0 0 24864 Arms and Armor 5 Blade and mounting for a dagger (Tantō) 1289 Blade and Mounting for a Dagger (Tantō) Japanese 35         Swordsmith|Fittings maker 91 Blade probably inscribed by|Chape and knife handle inscribed by Kage[masa]|Masaharu Japanese, Osafune, Bizen Province, active early 14th century|Japanese, active 19th century   Kage[masa]|Masaharu 2903 Japanese|Japanese 72 1300 |1801 1350 |1900 blade, dated 1322; mounting, 19th century 1322 1900 Steel, wood, lacquer, copper-gold alloy (shakudō), silver, gold 4348 L. 14 3/4 in. (37.4 cm); L. of blade 14 in. (35.5 cm); L. of cutting edge 10 1/16 in. (25.5 cm) Gift of J. Watson Webb Jr., 1972   Osafune 521   Bizen Province (present-day Okayama Prefecture) 179               Daggers 33   Metropolitan Museum of Art, New York, NY 1
21810 1998.127.1 0 0 26645 Arms and Armor 5 Blade and mounting for a dagger (Tantō) 1289 Blade and Mounting for a Dagger (Tantō) Japanese 35         Swordsmith|Fittings maker 91 Blade by|Mounting by Morimitsu|Ichiryuken Japanese, Muromachi period, active 15th century|Japanese, active 19th century   Morimitsu|Ichiryuken 2993 Japanese|Japanese 72 1401 |1801 1500 |1900 blade, dated 1425; mounting, 19th century 1425 1425 Steel, wood, lacquer, rayskin (samé), baleen, copper-silver alloy (shibuichi), silver 4814 L. 14 15/16 in. (37.9 cm); L. of blade 13 9/16 in. (34.5 cm); L. of cutting edge 9 11/16 in. (24.6 cm) Gift of Peter H. B. Frelinghuysen, 1998       Okayama Prefecture 98               Daggers 33   Metropolitan Museum of Art, New York, NY 1
22686 2007.478.1a–i 0 1 27599 Arms and Armor 5 Blade and mounting for a short sword (Wakizashi) 1294 Blade and Mounting for a Short Sword (Wakizashi) Japanese 35         Swordsmith|Fittings maker 91 Blade attributed to|Sword guard (Tsuba) inscribed by Fusamune of Soshu|Sōheishi Sōtensai Japanese, active ca. late 15th–early 16th century|Japanese, active 18th century   Fusamune of Soshu|Sōheishi Sōtensai 3028 Japanese 74 1450 |1701 1550 |1800 blade, late 15th–early 16th century; mounting, 18th century 1450 1800 Steel, wood, lacquer, ray skin (samé), silk, copper-gold alloy (shakudō), gold, silver 5140 L. 29 3/4 in. (75.7 cm); L. of blade 24 3/8 in. (62 cm); L. of cutting edge 19 5/8 in. (50 cm); D. of curvature 3/8 in. (0.9 cm) Gift of Etsuko O. Morris and John H. Morris Jr., in memory of Dr. Frederick M. Pedersen, 2007       Kanagawa Prefecture 149               Swords 29   Metropolitan Museum of Art, New York, NY 1
388522 36.120.419a–d, .420a–d 0 0 638592 Arms and Armor 5 Blades and mountings for a pair of swords (Daishō) 2824 Blades and Mountings for a Pair of Swords (Daishō) Japanese 35         Swordsmith|Fittings maker 91 Blades inscribed by|Fittings inscribed by Yokoyama Kōzukedaijō Sukesada|Miboku Japanese, 1627–1716|Japanese, 1695–1769   Sukesada, Yokoyama Kōzukedaijō|Miboku 2843 Japanese|Japanese 72 1627 |1695 1716 |1769 blades, 17th century; mountings, dated 1757 1601 1757 Steel, wood, lacquer, copper-gold alloy (shakudō), gold, copper-silver alloy (shibuichi), rayskin, silk 58325 L. of sword (katana) 37 1/2 in. (95.3 cm); L. of sword (katana) blade 28 in. (71.1 cm); L. of sword (katana) scabbard 29 in. (73.7 cm); L. of knife (kozuka) for sword (katana) mounting 8 1/2 in. (21.6 cm); L. of hair dressing tool (kogai) for sword (katana) mounting 8 1/4 in. (21.0 cm); L. of short sword (wakizashi) 25 in. (63.5 cm); L. of short sword (wakizashi) blade 20 3/4 in. (52.7 cm); L. of knife (kozuka) for short sword (wakizashi) mounting 8 1/2 in. (21.6 cm); L. of hair dressing tool (kogai) for short sword (wakizashi) mounting 8 1/4 in. (21.0 cm) The Howard Mansfield Collection, Gift of Howard Mansfield, 1936                       Swords 29   Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 118.544ms · Data license: CC0 · Data source: metmuseum/openaccess